<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.12.1" DotMatrixReport="False" EngineOptions.DoublePass="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4089" PreviewOptions.OutlineWidth="180" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.Author="EXATA Sistemas" ReportOptions.CreateDate="37871,9957952199" ReportOptions.Description.Text="Este relatório e parte integrante do SEAC - Sistema EXATA de Automação Comercial" ReportOptions.Name="Relatorios\Relação de Produtos Com EAN duplicado.prdrelfr4" ReportOptions.LastChange="44889,4479927546" ReportOptions.VersionBuild="0" ReportOptions.VersionMajor="1" ReportOptions.VersionMinor="0" ReportOptions.VersionRelease="0" ScriptLanguage="PascalScript" ScriptText.Text="var&#13;&#10;DataSet:TfrxDataSet;&#13;&#10;cCampos:string;&#13;&#10;cIndex:string;&#13;&#10;cDataSet:string;    &#13;&#10;cVazio:string;&#13;&#10;cSQL:string;&#13;&#10;  &#13;&#10;procedure Memo5OnAfterData(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;         If trim(&#60;Logo&#62;) = '' Then Begin&#13;&#10;               Nome_Fantasia.Left := 0;&#13;&#10;               Titulo1.Left := 0;                                                                          &#13;&#10;               Memo16.Left := 0;&#13;&#10;               Titulo2.Left := 0;&#13;&#10;               Titulo3.Left := 0;&#13;&#10;               Titulo4.Left := 0;                   &#13;&#10;               End;      &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;       picture1.FileLink := trim(&#60;Logo&#62;);&#13;&#10;&#13;&#10;       //**********************************************************************//&#13;&#10;       // Montando o DataSet                                                            &#13;&#10;       //**********************************************************************//                                                                                                                                                          &#13;&#10;       cCampos := '[Produto_EAN][Produto_Codigo][Produto_Descricao]';&#13;&#10;       cIndex := '[1][2][3]';&#13;&#10;       cVazio := '{{&#34;&#34;,0,&#34;&#34;}}';&#13;&#10;&#13;&#10;       CallHbFunc('Relatorio_DataSet',[cCampos,cIndex,cVazio]);&#13;&#10;       //**********************************************************************//                                                                                                                                                          &#13;&#10;    &#13;&#10;       //**********************************************************************//&#13;&#10;       // Populando o DataSet                                                            &#13;&#10;       //**********************************************************************//&#13;&#10;       cSQL := 'SELECT ';    &#13;&#10;       cSQL := cSQL+ 'pd_ean,';    &#13;&#10;       cSQL := cSQL+ 'pd_codigo,';  &#13;&#10;       cSQL := cSQL+ 'pd_nome ';     &#13;&#10;       cSQL := cSQL+ 'FROM produtos ';     &#13;&#10;       cSQL := cSQL+ 'WHERE sql_deleted = &#34;F&#34; ';     &#13;&#10;       cSQL := cSQL+ 'AND pd_ean IN ';  &#13;&#10;       cSQL := cSQL+ '( ';     &#13;&#10;       cSQL := cSQL+ 'SELECT pd_ean FROM (';  &#13;&#10;       cSQL := cSQL+ 'SELECT ';        &#13;&#10;       cSQL := cSQL+ 'COUNT(*) AS cont,';    &#13;&#10;       cSQL := cSQL+ 'pd_ean ';       &#13;&#10;       cSQL := cSQL+ 'FROM produtos ';      &#13;&#10;       cSQL := cSQL+ 'WHERE sql_deleted = &#34;F&#34; ';      &#13;&#10;       cSQL := cSQL+ 'GROUP BY 2 ';         &#13;&#10;       cSQL := cSQL+ 'HAVING cont &#62; 1 ) AS ean ';     &#13;&#10;       cSQL := cSQL+ ') ';     &#13;&#10;       cSQL := cSQL+ 'ORDER BY 1,2; ';     &#13;&#10;&#13;&#10;       CallHbFunc('Relatorio_PopulaDataSet',[cSQL,cVazio]);&#13;&#10;       //**********************************************************************//&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False" PropData="044C656674025803546F70026808446174617365747301010C2400000020446174615365743D226F444D2E2220446174615365744E616D653D22546162656C61220000095661726961626C657301010C0F000000204E616D653D222056657273616F2200010C20000000204E616D653D2256657273616F5F53697374656D61222056616C75653D22372200010C10000000204E616D653D22205265746F726E6F2200010C1F000000204E616D653D225265746F726E6F222056616C75653D222766616C7365272200010C10000000204E616D653D2220456D70726573612200010C4D000000204E616D653D2252617A616F5F536F6369616C222056616C75653D222756494C4152454A4F204445204D41434145204D415445524941495320444520434F4E5354525543414F204C544441272200010C3A000000204E616D653D224E6F6D655F46616E7461736961222056616C75653D222756696C6172656A6F202D20536F6C75E7E36F20656D2043617361272200010C1F000000204E616D653D224C6F6A61222056616C75653D2227446570F37369746F272200010C32000000204E616D653D22456E64657265636F222056616C75653D2227455354205345525241204D4152204B4D20382C352C2030272200010C1F000000204E616D653D224E756D65726F222056616C75653D2227202020202030272200010C1E000000204E616D653D22436F6D706C656D656E746F222056616C75653D2227272200010C23000000204E616D653D2242616972726F222056616C75653D222756494C41205645524445272200010C2A000000204E616D653D22436964616465222056616C75653D2227436173696D69726F206465204162726575272200010C17000000204E616D653D225546222056616C75653D2227524A272200010C1F000000204E616D653D22434550222056616C75653D222732383836302D303030272200010C33000000204E616D653D2254656C65666F6E65222056616C75653D22272832322920323736342D3035303020202020202020202020272200010C25000000204E616D653D22466178222056616C75653D2227282020292020202020202D20202020272200010C29000000204E616D653D2243656C756C6172222056616C75653D2227282020292020202020202D20202020272200010C29000000204E616D653D22434E504A222056616C75653D222733362E3537372E3534322F303030312D3739272200010C2A000000204E616D653D22496E73635F457374616475616C222056616C75653D222738362E3632302E323934272200010C29000000204E616D653D22496E73635F4D756E69636970616C222056616C75653D22273030303030303030272200010C2A000000204E616D653D2253697465222056616C75653D22277777772E76696C6172656A6F2E636F6D2E6272272200010C35000000204E616D653D22456D61696C222056616C75653D2227636F6E746162696C69646164654076696C6172656A6F2E636F6D2E6272272200010C17000000204E616D653D224C6F676F222056616C75653D2227272200010C28000000204E616D653D22536C6F67616E222056616C75653D2227736F6C75E7E36F20656D2063617361272200010C21000000204E616D653D22436F6469676F5F4C6F6A61222056616C75653D2227303031272200010C1E000000204E616D653D225465726D696E616C222056616C75653D2227303031272200010C0F000000204E616D653D2220546974756C6F2200010C1A000000204E616D653D22546974756C6F31222056616C75653D2227272200010C1A000000204E616D653D22546974756C6F32222056616C75653D2227272200010C1A000000204E616D653D22546974756C6F33222056616C75653D2227272200010C1A000000204E616D653D22546974756C6F34222056616C75653D2227272200010C1A000000204E616D653D22546974756C6F35222056616C75653D2227272200010C0E000000204E616D653D22204175746F722200010C2B000000204E616D653D224175746F725F4E6F6D65222056616C75653D222745584154412053697374656D6173272200010C32000000204E616D653D224175746F725F53697465222056616C75653D22277777772E657861746173697374656D61732E636F6D272200010C10000000204E616D653D2220436F6C756E61732200010C20000000204E616D653D224C6F6A6131222056616C75653D2227446570F37369746F272200010C1D000000204E616D653D224C6F6A6132222056616C75653D22274D616361E9272200010C21000000204E616D653D224C6F6A6133222056616C75653D22274361626F204672696F272200010C1E000000204E616D653D224C6F6A6134222056616C75653D222743616D706F73272200010C21000000204E616D653D224C6F6A6135222056616C75653D2227522E204F7374726173272200010C20000000204E616D653D224C6F6A6136222056616C75653D22274172617275616D61272200010C1F000000204E616D653D224C6F6A6137222056616C75653D22274E69746572F369272200010C22000000204E616D653D224C6F6A6138222056616C75653D222754656C6556656E646173272200010C22000000204E616D653D224C6F6A6139222056616C75653D2227522E204A616E6569726F272200010C1F000000204E616D653D224C6F6A613130222056616C75653D22274D61726963E1272200010C20000000204E616D653D224C6F6A613131222056616C75653D22274C6F6A61203131272200010C20000000204E616D653D224C6F6A613132222056616C75653D22274C6F6A61203132272200010C21000000204E616D653D2277686572655F70726F6475746F73222056616C75653D2227272200010C22000000204E616D653D2277686572655F70726F6475746F7361222056616C75653D2227272200010C24000000204E616D653D2277686572655F63635F70726F6475746F73222056616C75653D2227272200010C2B000000204E616D653D225175616E7469646164655F4C6F6A61222056616C75653D222770645F717464303031272200010C23000000204E616D653D224C6F6A615F53656C6563696F6E616461222056616C75653D2227272200010C1E000000204E616D653D226C4772616465222056616C75653D222766616C736527220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="7" RightMargin="7" TopMargin="7" BottomMargin="7" Columns="1" ColumnWidth="210" ColumnPositions.Text="0" PrintOnPreviousPage="True" HGuides.Text="" VGuides.Text="876,85096&#13;&#10;370,39394">
    <TfrxPageHeader Name="Band2" Height="151,35436" Left="0" Top="18,89765" Width="740,78788">
      <TfrxMemoView Name="Memo1" Left="-2,11812" Top="129,50402" Width="740,78740157" Height="18,89765" OnAfterData="Memo5OnAfterData" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-15" Font.Name="Arial" Font.Style="1" Frame.Typ="12" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxPictureView Name="Picture1" Left="1,22047" Top="0" Width="102,04724409" Height="102,04724409" ShowHint="False" Center="True" URL="[Site]" HightQuality="True" Transparent="False" TransparentColor="16777215"/>
      <TfrxMemoView Name="Nome_Fantasia" Left="113,04731" Top="3,10235" Width="627,74057" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Nome_Fantasia]"/>
      <TfrxMemoView Name="Emissao" Left="533,96104" Top="100,070934" Width="206,82684" Height="18,874026" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="EmissÃ£o: [Date] -  [Time]"/>
      <TfrxMemoView Name="Memo5" Left="188,9765" Top="128,67718" Width="370,39394" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="DescriÃ§Ã£o do Produto"/>
      <TfrxMemoView Name="Memo6" Left="124,23624" Top="128,67718" Width="53,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="CÃ³digo"/>
      <TfrxMemoView Name="Titulo1" Left="113,04731" Top="22,67718" Width="627,74057" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="RelaÃ§Ã£o de Produtos Com EAN Duplicado[IIF(&#60;Loja_Selecionada&#62;='',' (Loja: '+&#60;Loja1&#62;+')','')]"/>
      <TfrxMemoView Name="Titulo2" Left="113,3859" Top="60,47248" Width="627,40198" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Titulo2]"/>
      <TfrxMemoView Name="Titulo3" Left="113,04731" Top="79,37013" Width="627,74057" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Titulo3]"/>
      <TfrxMemoView Name="Titulo4" Left="113,04731" Top="96,26778" Width="416,08689" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Titulo4]"/>
      <TfrxMemoView Name="Memo16" Left="113,3859" Top="41,57483" Width="627,40198" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Titulo1]"/>
      <TfrxMemoView Name="Memo3" Left="2" Top="129,50402" Width="105,82684" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="EAN"/>
    </TfrxPageHeader>
    <TfrxPageFooter Name="Band3" Height="33,165368" Left="0" Top="306,14193" Width="740,78788">
      <TfrxMemoView Name="TotalPaginas" Left="0" Top="7,55906" Width="740,787401574803" Height="25,606308" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="4" Frame.Width="1,5" HAlign="haRight" ParentFont="False" Text="Total de registros: [Count(Band4)]&#13;&#10;PÃ¡gina: [Page] de [TotalPages]"/>
      <TfrxMemoView Name="SiteEXATA" Left="-1" Top="7,55905999999999" Width="255,661534" Height="15,11812" ShowHint="False" URL="[Autor_Site]" Font.Charset="1" Font.Color="16711680" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="[Autor_Site]"/>
    </TfrxPageFooter>
    <TfrxMasterData Name="Band4" Height="15,11811024" Left="0" Top="230,55133" Width="740,78788" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="oDM." DataSetName="Tabela" RowCount="0" Stretched="True">
      <TfrxMemoView Name="CorSimcorNao" Left="0" Top="0" Width="740,78740157" Height="15,1181102362205" ShowHint="False" StretchMode="smActualHeight" DataSetName="Customers" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Highlight.Font.Charset="1" Highlight.Font.Color="-370606080" Highlight.Font.Height="-12" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="15658734" Highlight.Condition="&#60;Line#&#62; mod 2" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="FornecedoresRazao_Social" Left="188,9765" Top="0" Width="370,39394" Height="15,11811024" ShowHint="False" StretchMode="smActualHeight" DataSetName="Vendas_Periodo" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haBlock" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Tabela.&#34;Produto_Nome&#34;]"/>
      <TfrxMemoView Name="FornecedoresCodigo_Fornecedor" Left="124,23624" Top="0" Width="53,40167" Height="15,11811024" ShowHint="False" DataSetName="Vendas_Periodo" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Tabela.&#34;Produto_Codigo&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="2" Top="0" Width="105,82684" Height="15,11811024" ShowHint="False" StretchMode="smActualHeight" DataField="Produto_EAN" DataSet="oDM." DataSetName="Tabela" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Tabela.&#34;Produto_EAN&#34;]"/>
    </TfrxMasterData>
    <TfrxMemoView Name="Atualizado" Left="9" Top="512,267718" Width="727,48825" Height="18,89765" Visible="False" ShowHint="False" Font.Charset="1" Font.Color="255" Font.Height="-17" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Relatorio Generico para os modulos do SEAC - Atualilzado em: 30/10/2012"/>
  </TfrxReportPage>
</TfrxReport>
